-
Re: How to Measure Smartsheet Usage/Adoption
The second part of your question is easily doable using formulas, however no sure on the first part (updates to the plan). There is however a manual way to check on sheet updates/activity via "A…1 · -
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then…3 · -
Re: I need help with a formula to count how many Associates is under each manager.
Assumption: Sheet 1 has Manager and Associate Name as 2 columns wherein each row has a Manager for a given Associate; You have unique Manager names in Sheet 2 (not mandatory but I am just assuming) I…1 · -
Re: Does not contain this or that TEXT
=IF(CONTAINS("E-Gift", Variation@row), "E-Gift Card", IF(CONTAINS("Physical Card", Variation@row), "Physical Gift Card", IF(NOT(CONTAINS("Card", Vari…1 · -
Re: #invalid Column Value Error
Glad it worked, and yes there are always interesting ways on how the functions can be used. I too keep learning through questions and suggestions in this forum.1 ·